  alter view [performance].[view_sales_record] as
	select m.submit_sales_key, m.submit_sales_sub_key, 
	p.agent_code, p.contract_num, p.sub_group_num, p.certificate_num, 
	p.lob,p.submit_date_time, p.submit_pc, p.submit_case_count, 
	p.proposal_owner_name,p.proposal_insured_name,p.basic_plan_name_chi,
	p.basic_plan_name_eng,p.coverage_plan_name_eng,p.coverage_plan_name_chi,
	d.reason_code,d.reason_code_desc,d.dpr_date, d.issue_pc, d.issue_case_count
	from [performance].[submit_sale] p
	left join [performance].[sales_map] m on m.submit_sales_key = p.submit_sales_key and m.submit_sales_sub_key = p.submit_sales_sub_key
	left join [performance].[issue_sale] d on m.issue_sales_key = d.issue_sales_key
GO